Tabela PhIngredient

Definicja tabeli PhIngredient

Name

PhIngredient

Code

PhIngredient

Comment

Skladniki leku


Lista kolumn tabeli PhIngredient

Name

Code

IngredientID

IngredientID

DrugID

DrugID

SubstID

SubstID

Dosage

Dosage

SubstType

SubstType

DosageUnitID

DosageUnitID


Kolumna IngredientID tabeli PhIngredient

Definicja kolumny IngredientID tabeli PhIngredient

Name

IngredientID

Code

IngredientID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DrugID tabeli PhIngredient

Definicja kolumny DrugID tabeli PhIngredient

Name

DrugID

Code

DrugID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SubstID tabeli PhIngredient

Definicja kolumny SubstID tabeli PhIngredient

Name

SubstID

Code

SubstID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Dosage tabeli PhIngredient

Definicja kolumny Dosage tabeli PhIngredient

Name

Dosage

Code

Dosage

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Dawka


Kolumna SubstType tabeli PhIngredient

Definicja kolumny SubstType tabeli PhIngredient

Name

SubstType

Code

SubstType

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Typ substancji


Kolumna DosageUnitID tabeli PhIngredient

Definicja kolumny DosageUnitID tabeli PhIngredient

Name

DosageUnitID

Code

DosageUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki dawki


Lista kluczy tabeli PhIngredient

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhIngredient

Definicja klucza Key_1 tabeli PhIngredient

Name

Key_1

Code

Key_1

Primary

Yes

Comment